package com.example.board.pojo.vo;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.*;
import com.alibaba.excel.enums.BooleanEnum;
import com.alibaba.excel.enums.poi.HorizontalAlignmentEnum;
import com.alibaba.excel.enums.poi.VerticalAlignmentEnum;
import lombok.*;

@Getter
@Setter
@NoArgsConstructor
@AllArgsConstructor
@Builder
@HeadStyle(horizontalAlignment = HorizontalAlignmentEnum.CENTER, verticalAlignment = VerticalAlignmentEnum.CENTER)
//标题样式,垂直水平居中
@HeadFontStyle(fontName = "微软雅黑", fontHeightInPoints = 11, bold = BooleanEnum.FALSE)//表头字体样式
@HeadRowHeight(value = 50)//表头行高
@ContentFontStyle(fontName = "微软雅黑", fontHeightInPoints = 11)//内容字体样式
@ContentRowHeight(value = 30)//内容行高
@ContentStyle(horizontalAlignment = HorizontalAlignmentEnum.CENTER, verticalAlignment = VerticalAlignmentEnum.CENTER)
//内容样式,垂直水平居中
public class ExcelListVo {
    @ExcelProperty(value = {"服务商"}, index = 0)
    @ColumnWidth(value = 20)
    String serviceProvider;//服务商
    @ExcelProperty(value = {"业务员"}, index = 1)
    @ColumnWidth(value = 16)
    String salesman;//业务员
    // 11月目标
    @ExcelProperty(value = { "录入拜访"}, index = 2)
    Integer visit1;//录入拜访
    @ExcelProperty(value = { "定制成交 "}, index = 3)
    Integer custom1;//录入拜访
    @ExcelProperty(value = { "标品袋"}, index = 4)
    Integer sample1;//录入拜访

    //第一周 目标
    @ExcelProperty(value = {"第一周", "目标", "录入拜访"}, index = 5)
    Integer visit2;//录入拜访
    @ExcelProperty(value = {"第一周", "目标", "定制成交"}, index = 6)
    Integer custom2;//录入拜访
    @ExcelProperty(value = {"第一周", "目标", "标品袋"}, index = 7)
    Integer sample2;//录入拜访

    // 达成
    @ExcelProperty(value = {"第一周", "达成", "录入拜访"}, index = 8)
    Integer visit3;//录入拜访
    @ExcelProperty(value = {"第一周", "达成", "定制成交"}, index = 9)
    Integer custom3;//录入拜访
    @ExcelProperty(value = {"第一周", "达成", "标品袋"}, index = 10)
    Integer sample3;//录入拜访

    //差异
    @ExcelProperty(value = {"第一周", "差异", "录入拜访"}, index = 11)
    Integer visit4;//录入拜访
    @ExcelProperty(value = {"第一周", "差异", "定制成交"}, index = 12)
    Integer custom4;//录入拜访
    @ExcelProperty(value = {"第一周", "差异", "标品袋"}, index = 13)
    Integer sample4;//录入拜访

    //第二周 目标
    @ExcelProperty(value = {"第二周", "目标", "录入拜访"}, index = 14)
    Integer visit5;//录入拜访
    @ExcelProperty(value = {"第二周", "目标", "定制成交"}, index = 15)
    Integer custom5;//录入拜访
    @ExcelProperty(value = {"第二周", "目标", "标品袋"}, index = 16)
    Integer sample5;//录入拜访

    // 达成
    @ExcelProperty(value = {"第二周", "达成", "录入拜访"}, index = 17)
    Integer visit6;//录入拜访
    @ExcelProperty(value = {"第二周", "达成", "定制成交"}, index = 18)
    Integer custom6;//录入拜访
    @ExcelProperty(value = {"第二周", "达成", "标品袋"}, index = 19)
    Integer sample6;//录入拜访

    //差异
    @ExcelProperty(value = {"第二周", "差异", "录入拜访"}, index = 20)
    Integer visit7;//录入拜访
    @ExcelProperty(value = {"第二周", "差异", "定制成交"}, index = 21)
    Integer custom7;//录入拜访
    @ExcelProperty(value = {"第二周", "差异", "标品袋"}, index = 22)
    Integer sample7;//录入拜访


    //第三周 目标
    @ExcelProperty(value = {"第三周", "目标", "录入拜访"}, index = 23)
    Integer visit8;//录入拜访
    @ExcelProperty(value = {"第三周", "目标", "定制成交"}, index = 24)
    Integer custom8;//录入拜访
    @ExcelProperty(value = {"第三周", "目标", "标品袋"}, index = 25)
    Integer sample8;//录入拜访

    // 达成
    @ExcelProperty(value = {"第三周", "达成", "录入拜访"}, index = 26)
    Integer visit9;//录入拜访
    @ExcelProperty(value = {"第三周", "达成", "定制成交"}, index = 27)
    Integer custom9;//录入拜访
    @ExcelProperty(value = {"第三周", "达成", "标品袋"}, index = 28)
    Integer sample9;//录入拜访

    //差异
    @ExcelProperty(value = {"第三周", "差异", "录入拜访"}, index = 29)
    Integer visit10;//录入拜访
    @ExcelProperty(value = {"第三周", "差异", "定制成交"}, index = 30)
    Integer custom10;//录入拜访
    @ExcelProperty(value = {"第三周", "差异", "标品袋"}, index = 31)
    Integer sample10;//录入拜访

    //第四周 目标
    @ExcelProperty(value = {"第四周", "目标", "录入拜访"}, index = 32)
    Integer visit11;//录入拜访
    @ExcelProperty(value = {"第四周", "目标", "定制成交"}, index = 33)
    Integer custom11;//录入拜访
    @ExcelProperty(value = {"第四周", "目标", "标品袋"}, index = 34)
    Integer sample11;//录入拜访

    // 达成
    @ExcelProperty(value = {"第四周", "达成", "录入拜访"}, index = 35)
    Integer visit12;//录入拜访
    @ExcelProperty(value = {"第四周", "达成", "定制成交"}, index = 36)
    Integer custom12;//录入拜访
    @ExcelProperty(value = {"第四周", "达成", "标品袋"}, index = 37)
    Integer sample12;//录入拜访

    //差异
    @ExcelProperty(value = {"第四周", "差异", "录入拜访"}, index = 38)
    Integer visit13;//录入拜访
    @ExcelProperty(value = {"第四周", "差异", "定制成交"}, index = 39)
    Integer custom13;//录入拜访
    @ExcelProperty(value = {"第四周", "差异", "标品袋"}, index = 40)
    Integer sample13;//录入拜访

    //全月累计 达成
    @ExcelProperty(value = {"全月累计", "达成", "录入拜访"}, index = 41)
    Integer visit14;//录入拜访
    @ExcelProperty(value = {"全月累计", "达成", "定制成交"}, index = 42)
    Integer custom14;//录入拜访
    @ExcelProperty(value = {"全月累计", "达成", "标品袋"}, index = 43)
    Integer sample14;//录入拜访

    //  差异
    @ExcelProperty(value = {"全月累计", "差异", "录入拜访"}, index = 44)
    Integer visit15;//录入拜访
    @ExcelProperty(value = {"全月累计", "差异", "定制成交"}, index = 45)
    Integer custom15;//录入拜访
    @ExcelProperty(value = {"全月累计", "差异", "标品袋"}, index = 46)
    Integer sample15;//录入拜访
}
